package framework.office.apache.poi.xls;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.DataFormat;
public class test {
	public static void main(String[] args) {
		loadXls("");
	}
	public static void loadXls(String filePath) {
		try {
			InputStream input = new FileInputStream("C:/Users/K/Desktop/1/1.xls");
			POIFSFileSystem fs = new POIFSFileSystem(input);
			HSSFWorkbook wb = new HSSFWorkbook(fs);
			HSSFSheet sheet = wb.getSheetAt(0);
			HSSFRow row0 = sheet.getRow(0);
			System.out.println(row0.getFirstCellNum());
			HSSFCell cell0 = row0.getCell(row0.getFirstCellNum());
			HSSFCellStyle type = cell0.getCellStyle();
			System.out.println(type.getDataFormatString());
			// Iterate over each row in the sheet
			Iterator rows = sheet.rowIterator();
			while (rows.hasNext()) {
				HSSFRow row = (HSSFRow) rows.next();
				// System.out.println("Row #" + row.getRowNum());
				// Iterate over each cell in the row and print out the cell"s
				// content
				Iterator cells = row.cellIterator();
				while (cells.hasNext()) {
					HSSFCell cell = (HSSFCell) cells.next();
					// System.out.println("Cell #" + cell.getCellNum());
					switch (cell.getCellType()) {
						case HSSFCell.CELL_TYPE_NUMERIC :
							// System.out.println(cell.getNumericCellValue());
							break;
						case HSSFCell.CELL_TYPE_STRING :
							// System.out.println(cell.getStringCellValue());
							break;
						case HSSFCell.CELL_TYPE_BOOLEAN :
							// System.out.println(cell.getBooleanCellValue());
							break;
						case HSSFCell.CELL_TYPE_FORMULA :
							// System.out.println(cell.getCellFormula());
							break;
						default :
							// System.out.println("unsuported sell type");
							break;
					}
				}
			}
		} catch (IOException ex) {
			ex.printStackTrace();
		}
	}
}
